package com.jsz.peini.bean.seller;

import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class CompanyInfoExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public CompanyInfoExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("id is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("id is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(Integer value) {
            addCriterion("id =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Integer value) {
            addCriterion("id <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Integer value) {
            addCriterion("id >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("id >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Integer value) {
            addCriterion("id <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Integer value) {
            addCriterion("id <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Integer> values) {
            addCriterion("id in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Integer> values) {
            addCriterion("id not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(Integer value1, Integer value2) {
            addCriterion("id between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Integer value1, Integer value2) {
            addCriterion("id not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNull() {
            addCriterion("company_name is null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIsNotNull() {
            addCriterion("company_name is not null");
            return (Criteria) this;
        }

        public Criteria andCompanyNameEqualTo(String value) {
            addCriterion("company_name =", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotEqualTo(String value) {
            addCriterion("company_name <>", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThan(String value) {
            addCriterion("company_name >", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameGreaterThanOrEqualTo(String value) {
            addCriterion("company_name >=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThan(String value) {
            addCriterion("company_name <", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLessThanOrEqualTo(String value) {
            addCriterion("company_name <=", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameLike(String value) {
            addCriterion("company_name like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotLike(String value) {
            addCriterion("company_name not like", value, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameIn(List<String> values) {
            addCriterion("company_name in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotIn(List<String> values) {
            addCriterion("company_name not in", values, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameBetween(String value1, String value2) {
            addCriterion("company_name between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andCompanyNameNotBetween(String value1, String value2) {
            addCriterion("company_name not between", value1, value2, "companyName");
            return (Criteria) this;
        }

        public Criteria andPersonIsNull() {
            addCriterion("person is null");
            return (Criteria) this;
        }

        public Criteria andPersonIsNotNull() {
            addCriterion("person is not null");
            return (Criteria) this;
        }

        public Criteria andPersonEqualTo(String value) {
            addCriterion("person =", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonNotEqualTo(String value) {
            addCriterion("person <>", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonGreaterThan(String value) {
            addCriterion("person >", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonGreaterThanOrEqualTo(String value) {
            addCriterion("person >=", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonLessThan(String value) {
            addCriterion("person <", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonLessThanOrEqualTo(String value) {
            addCriterion("person <=", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonLike(String value) {
            addCriterion("person like", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonNotLike(String value) {
            addCriterion("person not like", value, "person");
            return (Criteria) this;
        }

        public Criteria andPersonIn(List<String> values) {
            addCriterion("person in", values, "person");
            return (Criteria) this;
        }

        public Criteria andPersonNotIn(List<String> values) {
            addCriterion("person not in", values, "person");
            return (Criteria) this;
        }

        public Criteria andPersonBetween(String value1, String value2) {
            addCriterion("person between", value1, value2, "person");
            return (Criteria) this;
        }

        public Criteria andPersonNotBetween(String value1, String value2) {
            addCriterion("person not between", value1, value2, "person");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andAgreenoIsNull() {
            addCriterion("agreeNo is null");
            return (Criteria) this;
        }

        public Criteria andAgreenoIsNotNull() {
            addCriterion("agreeNo is not null");
            return (Criteria) this;
        }

        public Criteria andAgreenoEqualTo(String value) {
            addCriterion("agreeNo =", value, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoNotEqualTo(String value) {
            addCriterion("agreeNo <>", value, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoGreaterThan(String value) {
            addCriterion("agreeNo >", value, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoGreaterThanOrEqualTo(String value) {
            addCriterion("agreeNo >=", value, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoLessThan(String value) {
            addCriterion("agreeNo <", value, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoLessThanOrEqualTo(String value) {
            addCriterion("agreeNo <=", value, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoLike(String value) {
            addCriterion("agreeNo like", value, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoNotLike(String value) {
            addCriterion("agreeNo not like", value, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoIn(List<String> values) {
            addCriterion("agreeNo in", values, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoNotIn(List<String> values) {
            addCriterion("agreeNo not in", values, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoBetween(String value1, String value2) {
            addCriterion("agreeNo between", value1, value2, "agreeno");
            return (Criteria) this;
        }

        public Criteria andAgreenoNotBetween(String value1, String value2) {
            addCriterion("agreeNo not between", value1, value2, "agreeno");
            return (Criteria) this;
        }

        public Criteria andMailnoIsNull() {
            addCriterion("mailNo is null");
            return (Criteria) this;
        }

        public Criteria andMailnoIsNotNull() {
            addCriterion("mailNo is not null");
            return (Criteria) this;
        }

        public Criteria andMailnoEqualTo(String value) {
            addCriterion("mailNo =", value, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoNotEqualTo(String value) {
            addCriterion("mailNo <>", value, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoGreaterThan(String value) {
            addCriterion("mailNo >", value, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoGreaterThanOrEqualTo(String value) {
            addCriterion("mailNo >=", value, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoLessThan(String value) {
            addCriterion("mailNo <", value, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoLessThanOrEqualTo(String value) {
            addCriterion("mailNo <=", value, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoLike(String value) {
            addCriterion("mailNo like", value, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoNotLike(String value) {
            addCriterion("mailNo not like", value, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoIn(List<String> values) {
            addCriterion("mailNo in", values, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoNotIn(List<String> values) {
            addCriterion("mailNo not in", values, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoBetween(String value1, String value2) {
            addCriterion("mailNo between", value1, value2, "mailno");
            return (Criteria) this;
        }

        public Criteria andMailnoNotBetween(String value1, String value2) {
            addCriterion("mailNo not between", value1, value2, "mailno");
            return (Criteria) this;
        }

        public Criteria andQqIsNull() {
            addCriterion("QQ is null");
            return (Criteria) this;
        }

        public Criteria andQqIsNotNull() {
            addCriterion("QQ is not null");
            return (Criteria) this;
        }

        public Criteria andQqEqualTo(String value) {
            addCriterion("QQ =", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotEqualTo(String value) {
            addCriterion("QQ <>", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqGreaterThan(String value) {
            addCriterion("QQ >", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqGreaterThanOrEqualTo(String value) {
            addCriterion("QQ >=", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLessThan(String value) {
            addCriterion("QQ <", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLessThanOrEqualTo(String value) {
            addCriterion("QQ <=", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqLike(String value) {
            addCriterion("QQ like", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotLike(String value) {
            addCriterion("QQ not like", value, "qq");
            return (Criteria) this;
        }

        public Criteria andQqIn(List<String> values) {
            addCriterion("QQ in", values, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotIn(List<String> values) {
            addCriterion("QQ not in", values, "qq");
            return (Criteria) this;
        }

        public Criteria andQqBetween(String value1, String value2) {
            addCriterion("QQ between", value1, value2, "qq");
            return (Criteria) this;
        }

        public Criteria andQqNotBetween(String value1, String value2) {
            addCriterion("QQ not between", value1, value2, "qq");
            return (Criteria) this;
        }

        public Criteria andProvinceidIsNull() {
            addCriterion("provinceId is null");
            return (Criteria) this;
        }

        public Criteria andProvinceidIsNotNull() {
            addCriterion("provinceId is not null");
            return (Criteria) this;
        }

        public Criteria andProvinceidEqualTo(Integer value) {
            addCriterion("provinceId =", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotEqualTo(Integer value) {
            addCriterion("provinceId <>", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidGreaterThan(Integer value) {
            addCriterion("provinceId >", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidGreaterThanOrEqualTo(Integer value) {
            addCriterion("provinceId >=", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidLessThan(Integer value) {
            addCriterion("provinceId <", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidLessThanOrEqualTo(Integer value) {
            addCriterion("provinceId <=", value, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidIn(List<Integer> values) {
            addCriterion("provinceId in", values, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotIn(List<Integer> values) {
            addCriterion("provinceId not in", values, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidBetween(Integer value1, Integer value2) {
            addCriterion("provinceId between", value1, value2, "provinceid");
            return (Criteria) this;
        }

        public Criteria andProvinceidNotBetween(Integer value1, Integer value2) {
            addCriterion("provinceId not between", value1, value2, "provinceid");
            return (Criteria) this;
        }

        public Criteria andCityidIsNull() {
            addCriterion("cityId is null");
            return (Criteria) this;
        }

        public Criteria andCityidIsNotNull() {
            addCriterion("cityId is not null");
            return (Criteria) this;
        }

        public Criteria andCityidEqualTo(Integer value) {
            addCriterion("cityId =", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotEqualTo(Integer value) {
            addCriterion("cityId <>", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidGreaterThan(Integer value) {
            addCriterion("cityId >", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidGreaterThanOrEqualTo(Integer value) {
            addCriterion("cityId >=", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLessThan(Integer value) {
            addCriterion("cityId <", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidLessThanOrEqualTo(Integer value) {
            addCriterion("cityId <=", value, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidIn(List<Integer> values) {
            addCriterion("cityId in", values, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotIn(List<Integer> values) {
            addCriterion("cityId not in", values, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidBetween(Integer value1, Integer value2) {
            addCriterion("cityId between", value1, value2, "cityid");
            return (Criteria) this;
        }

        public Criteria andCityidNotBetween(Integer value1, Integer value2) {
            addCriterion("cityId not between", value1, value2, "cityid");
            return (Criteria) this;
        }

        public Criteria andDistidIsNull() {
            addCriterion("distId is null");
            return (Criteria) this;
        }

        public Criteria andDistidIsNotNull() {
            addCriterion("distId is not null");
            return (Criteria) this;
        }

        public Criteria andDistidEqualTo(Integer value) {
            addCriterion("distId =", value, "distid");
            return (Criteria) this;
        }

        public Criteria andDistidNotEqualTo(Integer value) {
            addCriterion("distId <>", value, "distid");
            return (Criteria) this;
        }

        public Criteria andDistidGreaterThan(Integer value) {
            addCriterion("distId >", value, "distid");
            return (Criteria) this;
        }

        public Criteria andDistidGreaterThanOrEqualTo(Integer value) {
            addCriterion("distId >=", value, "distid");
            return (Criteria) this;
        }

        public Criteria andDistidLessThan(Integer value) {
            addCriterion("distId <", value, "distid");
            return (Criteria) this;
        }

        public Criteria andDistidLessThanOrEqualTo(Integer value) {
            addCriterion("distId <=", value, "distid");
            return (Criteria) this;
        }

        public Criteria andDistidIn(List<Integer> values) {
            addCriterion("distId in", values, "distid");
            return (Criteria) this;
        }

        public Criteria andDistidNotIn(List<Integer> values) {
            addCriterion("distId not in", values, "distid");
            return (Criteria) this;
        }

        public Criteria andDistidBetween(Integer value1, Integer value2) {
            addCriterion("distId between", value1, value2, "distid");
            return (Criteria) this;
        }

        public Criteria andDistidNotBetween(Integer value1, Integer value2) {
            addCriterion("distId not between", value1, value2, "distid");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateIsNull() {
            addCriterion("agreeStartDate is null");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateIsNotNull() {
            addCriterion("agreeStartDate is not null");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateEqualTo(Date value) {
            addCriterionForJDBCDate("agreeStartDate =", value, "agreestartdate");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateNotEqualTo(Date value) {
            addCriterionForJDBCDate("agreeStartDate <>", value, "agreestartdate");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateGreaterThan(Date value) {
            addCriterionForJDBCDate("agreeStartDate >", value, "agreestartdate");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("agreeStartDate >=", value, "agreestartdate");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateLessThan(Date value) {
            addCriterionForJDBCDate("agreeStartDate <", value, "agreestartdate");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("agreeStartDate <=", value, "agreestartdate");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateIn(List<Date> values) {
            addCriterionForJDBCDate("agreeStartDate in", values, "agreestartdate");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateNotIn(List<Date> values) {
            addCriterionForJDBCDate("agreeStartDate not in", values, "agreestartdate");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("agreeStartDate between", value1, value2, "agreestartdate");
            return (Criteria) this;
        }

        public Criteria andAgreestartdateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("agreeStartDate not between", value1, value2, "agreestartdate");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateIsNull() {
            addCriterion("agreeEndDate is null");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateIsNotNull() {
            addCriterion("agreeEndDate is not null");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateEqualTo(Date value) {
            addCriterionForJDBCDate("agreeEndDate =", value, "agreeenddate");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateNotEqualTo(Date value) {
            addCriterionForJDBCDate("agreeEndDate <>", value, "agreeenddate");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateGreaterThan(Date value) {
            addCriterionForJDBCDate("agreeEndDate >", value, "agreeenddate");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("agreeEndDate >=", value, "agreeenddate");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateLessThan(Date value) {
            addCriterionForJDBCDate("agreeEndDate <", value, "agreeenddate");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("agreeEndDate <=", value, "agreeenddate");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateIn(List<Date> values) {
            addCriterionForJDBCDate("agreeEndDate in", values, "agreeenddate");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateNotIn(List<Date> values) {
            addCriterionForJDBCDate("agreeEndDate not in", values, "agreeenddate");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("agreeEndDate between", value1, value2, "agreeenddate");
            return (Criteria) this;
        }

        public Criteria andAgreeenddateNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("agreeEndDate not between", value1, value2, "agreeenddate");
            return (Criteria) this;
        }

        public Criteria andPoclearIsNull() {
            addCriterion("POClear is null");
            return (Criteria) this;
        }

        public Criteria andPoclearIsNotNull() {
            addCriterion("POClear is not null");
            return (Criteria) this;
        }

        public Criteria andPoclearEqualTo(Integer value) {
            addCriterion("POClear =", value, "poclear");
            return (Criteria) this;
        }

        public Criteria andPoclearNotEqualTo(Integer value) {
            addCriterion("POClear <>", value, "poclear");
            return (Criteria) this;
        }

        public Criteria andPoclearGreaterThan(Integer value) {
            addCriterion("POClear >", value, "poclear");
            return (Criteria) this;
        }

        public Criteria andPoclearGreaterThanOrEqualTo(Integer value) {
            addCriterion("POClear >=", value, "poclear");
            return (Criteria) this;
        }

        public Criteria andPoclearLessThan(Integer value) {
            addCriterion("POClear <", value, "poclear");
            return (Criteria) this;
        }

        public Criteria andPoclearLessThanOrEqualTo(Integer value) {
            addCriterion("POClear <=", value, "poclear");
            return (Criteria) this;
        }

        public Criteria andPoclearIn(List<Integer> values) {
            addCriterion("POClear in", values, "poclear");
            return (Criteria) this;
        }

        public Criteria andPoclearNotIn(List<Integer> values) {
            addCriterion("POClear not in", values, "poclear");
            return (Criteria) this;
        }

        public Criteria andPoclearBetween(Integer value1, Integer value2) {
            addCriterion("POClear between", value1, value2, "poclear");
            return (Criteria) this;
        }

        public Criteria andPoclearNotBetween(Integer value1, Integer value2) {
            addCriterion("POClear not between", value1, value2, "poclear");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyIsNull() {
            addCriterion("agreeMoney is null");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyIsNotNull() {
            addCriterion("agreeMoney is not null");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyEqualTo(Long value) {
            addCriterion("agreeMoney =", value, "agreemoney");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNotEqualTo(Long value) {
            addCriterion("agreeMoney <>", value, "agreemoney");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyGreaterThan(Long value) {
            addCriterion("agreeMoney >", value, "agreemoney");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyGreaterThanOrEqualTo(Long value) {
            addCriterion("agreeMoney >=", value, "agreemoney");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyLessThan(Long value) {
            addCriterion("agreeMoney <", value, "agreemoney");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyLessThanOrEqualTo(Long value) {
            addCriterion("agreeMoney <=", value, "agreemoney");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyIn(List<Long> values) {
            addCriterion("agreeMoney in", values, "agreemoney");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNotIn(List<Long> values) {
            addCriterion("agreeMoney not in", values, "agreemoney");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyBetween(Long value1, Long value2) {
            addCriterion("agreeMoney between", value1, value2, "agreemoney");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNotBetween(Long value1, Long value2) {
            addCriterion("agreeMoney not between", value1, value2, "agreemoney");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowIsNull() {
            addCriterion("agreeMoney_now is null");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowIsNotNull() {
            addCriterion("agreeMoney_now is not null");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowEqualTo(Long value) {
            addCriterion("agreeMoney_now =", value, "agreemoneyNow");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowNotEqualTo(Long value) {
            addCriterion("agreeMoney_now <>", value, "agreemoneyNow");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowGreaterThan(Long value) {
            addCriterion("agreeMoney_now >", value, "agreemoneyNow");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowGreaterThanOrEqualTo(Long value) {
            addCriterion("agreeMoney_now >=", value, "agreemoneyNow");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowLessThan(Long value) {
            addCriterion("agreeMoney_now <", value, "agreemoneyNow");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowLessThanOrEqualTo(Long value) {
            addCriterion("agreeMoney_now <=", value, "agreemoneyNow");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowIn(List<Long> values) {
            addCriterion("agreeMoney_now in", values, "agreemoneyNow");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowNotIn(List<Long> values) {
            addCriterion("agreeMoney_now not in", values, "agreemoneyNow");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowBetween(Long value1, Long value2) {
            addCriterion("agreeMoney_now between", value1, value2, "agreemoneyNow");
            return (Criteria) this;
        }

        public Criteria andAgreemoneyNowNotBetween(Long value1, Long value2) {
            addCriterion("agreeMoney_now not between", value1, value2, "agreemoneyNow");
            return (Criteria) this;
        }

        public Criteria andClearcycleIsNull() {
            addCriterion("clearCycle is null");
            return (Criteria) this;
        }

        public Criteria andClearcycleIsNotNull() {
            addCriterion("clearCycle is not null");
            return (Criteria) this;
        }

        public Criteria andClearcycleEqualTo(Integer value) {
            addCriterion("clearCycle =", value, "clearcycle");
            return (Criteria) this;
        }

        public Criteria andClearcycleNotEqualTo(Integer value) {
            addCriterion("clearCycle <>", value, "clearcycle");
            return (Criteria) this;
        }

        public Criteria andClearcycleGreaterThan(Integer value) {
            addCriterion("clearCycle >", value, "clearcycle");
            return (Criteria) this;
        }

        public Criteria andClearcycleGreaterThanOrEqualTo(Integer value) {
            addCriterion("clearCycle >=", value, "clearcycle");
            return (Criteria) this;
        }

        public Criteria andClearcycleLessThan(Integer value) {
            addCriterion("clearCycle <", value, "clearcycle");
            return (Criteria) this;
        }

        public Criteria andClearcycleLessThanOrEqualTo(Integer value) {
            addCriterion("clearCycle <=", value, "clearcycle");
            return (Criteria) this;
        }

        public Criteria andClearcycleIn(List<Integer> values) {
            addCriterion("clearCycle in", values, "clearcycle");
            return (Criteria) this;
        }

        public Criteria andClearcycleNotIn(List<Integer> values) {
            addCriterion("clearCycle not in", values, "clearcycle");
            return (Criteria) this;
        }

        public Criteria andClearcycleBetween(Integer value1, Integer value2) {
            addCriterion("clearCycle between", value1, value2, "clearcycle");
            return (Criteria) this;
        }

        public Criteria andClearcycleNotBetween(Integer value1, Integer value2) {
            addCriterion("clearCycle not between", value1, value2, "clearcycle");
            return (Criteria) this;
        }

        public Criteria andLegalpersonIsNull() {
            addCriterion("legalPerson is null");
            return (Criteria) this;
        }

        public Criteria andLegalpersonIsNotNull() {
            addCriterion("legalPerson is not null");
            return (Criteria) this;
        }

        public Criteria andLegalpersonEqualTo(String value) {
            addCriterion("legalPerson =", value, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonNotEqualTo(String value) {
            addCriterion("legalPerson <>", value, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonGreaterThan(String value) {
            addCriterion("legalPerson >", value, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonGreaterThanOrEqualTo(String value) {
            addCriterion("legalPerson >=", value, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonLessThan(String value) {
            addCriterion("legalPerson <", value, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonLessThanOrEqualTo(String value) {
            addCriterion("legalPerson <=", value, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonLike(String value) {
            addCriterion("legalPerson like", value, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonNotLike(String value) {
            addCriterion("legalPerson not like", value, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonIn(List<String> values) {
            addCriterion("legalPerson in", values, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonNotIn(List<String> values) {
            addCriterion("legalPerson not in", values, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonBetween(String value1, String value2) {
            addCriterion("legalPerson between", value1, value2, "legalperson");
            return (Criteria) this;
        }

        public Criteria andLegalpersonNotBetween(String value1, String value2) {
            addCriterion("legalPerson not between", value1, value2, "legalperson");
            return (Criteria) this;
        }

        public Criteria andIdcardnoIsNull() {
            addCriterion("idCardNo is null");
            return (Criteria) this;
        }

        public Criteria andIdcardnoIsNotNull() {
            addCriterion("idCardNo is not null");
            return (Criteria) this;
        }

        public Criteria andIdcardnoEqualTo(String value) {
            addCriterion("idCardNo =", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotEqualTo(String value) {
            addCriterion("idCardNo <>", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoGreaterThan(String value) {
            addCriterion("idCardNo >", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoGreaterThanOrEqualTo(String value) {
            addCriterion("idCardNo >=", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoLessThan(String value) {
            addCriterion("idCardNo <", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoLessThanOrEqualTo(String value) {
            addCriterion("idCardNo <=", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoLike(String value) {
            addCriterion("idCardNo like", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotLike(String value) {
            addCriterion("idCardNo not like", value, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoIn(List<String> values) {
            addCriterion("idCardNo in", values, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotIn(List<String> values) {
            addCriterion("idCardNo not in", values, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoBetween(String value1, String value2) {
            addCriterion("idCardNo between", value1, value2, "idcardno");
            return (Criteria) this;
        }

        public Criteria andIdcardnoNotBetween(String value1, String value2) {
            addCriterion("idCardNo not between", value1, value2, "idcardno");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoIsNull() {
            addCriterion("zhizhaoNo is null");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoIsNotNull() {
            addCriterion("zhizhaoNo is not null");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoEqualTo(String value) {
            addCriterion("zhizhaoNo =", value, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoNotEqualTo(String value) {
            addCriterion("zhizhaoNo <>", value, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoGreaterThan(String value) {
            addCriterion("zhizhaoNo >", value, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoGreaterThanOrEqualTo(String value) {
            addCriterion("zhizhaoNo >=", value, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoLessThan(String value) {
            addCriterion("zhizhaoNo <", value, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoLessThanOrEqualTo(String value) {
            addCriterion("zhizhaoNo <=", value, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoLike(String value) {
            addCriterion("zhizhaoNo like", value, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoNotLike(String value) {
            addCriterion("zhizhaoNo not like", value, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoIn(List<String> values) {
            addCriterion("zhizhaoNo in", values, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoNotIn(List<String> values) {
            addCriterion("zhizhaoNo not in", values, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoBetween(String value1, String value2) {
            addCriterion("zhizhaoNo between", value1, value2, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaonoNotBetween(String value1, String value2) {
            addCriterion("zhizhaoNo not between", value1, value2, "zhizhaono");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonIsNull() {
            addCriterion("zhizhaoLegalPerson is null");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonIsNotNull() {
            addCriterion("zhizhaoLegalPerson is not null");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonEqualTo(String value) {
            addCriterion("zhizhaoLegalPerson =", value, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonNotEqualTo(String value) {
            addCriterion("zhizhaoLegalPerson <>", value, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonGreaterThan(String value) {
            addCriterion("zhizhaoLegalPerson >", value, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonGreaterThanOrEqualTo(String value) {
            addCriterion("zhizhaoLegalPerson >=", value, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonLessThan(String value) {
            addCriterion("zhizhaoLegalPerson <", value, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonLessThanOrEqualTo(String value) {
            addCriterion("zhizhaoLegalPerson <=", value, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonLike(String value) {
            addCriterion("zhizhaoLegalPerson like", value, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonNotLike(String value) {
            addCriterion("zhizhaoLegalPerson not like", value, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonIn(List<String> values) {
            addCriterion("zhizhaoLegalPerson in", values, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonNotIn(List<String> values) {
            addCriterion("zhizhaoLegalPerson not in", values, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonBetween(String value1, String value2) {
            addCriterion("zhizhaoLegalPerson between", value1, value2, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andZhizhaolegalpersonNotBetween(String value1, String value2) {
            addCriterion("zhizhaoLegalPerson not between", value1, value2, "zhizhaolegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoIsNull() {
            addCriterion("cateLicenseNo is null");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoIsNotNull() {
            addCriterion("cateLicenseNo is not null");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoEqualTo(String value) {
            addCriterion("cateLicenseNo =", value, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoNotEqualTo(String value) {
            addCriterion("cateLicenseNo <>", value, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoGreaterThan(String value) {
            addCriterion("cateLicenseNo >", value, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoGreaterThanOrEqualTo(String value) {
            addCriterion("cateLicenseNo >=", value, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoLessThan(String value) {
            addCriterion("cateLicenseNo <", value, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoLessThanOrEqualTo(String value) {
            addCriterion("cateLicenseNo <=", value, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoLike(String value) {
            addCriterion("cateLicenseNo like", value, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoNotLike(String value) {
            addCriterion("cateLicenseNo not like", value, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoIn(List<String> values) {
            addCriterion("cateLicenseNo in", values, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoNotIn(List<String> values) {
            addCriterion("cateLicenseNo not in", values, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoBetween(String value1, String value2) {
            addCriterion("cateLicenseNo between", value1, value2, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelicensenoNotBetween(String value1, String value2) {
            addCriterion("cateLicenseNo not between", value1, value2, "catelicenseno");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonIsNull() {
            addCriterion("cateLegalPerson is null");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonIsNotNull() {
            addCriterion("cateLegalPerson is not null");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonEqualTo(String value) {
            addCriterion("cateLegalPerson =", value, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonNotEqualTo(String value) {
            addCriterion("cateLegalPerson <>", value, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonGreaterThan(String value) {
            addCriterion("cateLegalPerson >", value, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonGreaterThanOrEqualTo(String value) {
            addCriterion("cateLegalPerson >=", value, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonLessThan(String value) {
            addCriterion("cateLegalPerson <", value, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonLessThanOrEqualTo(String value) {
            addCriterion("cateLegalPerson <=", value, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonLike(String value) {
            addCriterion("cateLegalPerson like", value, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonNotLike(String value) {
            addCriterion("cateLegalPerson not like", value, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonIn(List<String> values) {
            addCriterion("cateLegalPerson in", values, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonNotIn(List<String> values) {
            addCriterion("cateLegalPerson not in", values, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonBetween(String value1, String value2) {
            addCriterion("cateLegalPerson between", value1, value2, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelegalpersonNotBetween(String value1, String value2) {
            addCriterion("cateLegalPerson not between", value1, value2, "catelegalperson");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgIsNull() {
            addCriterion("cateLicenceImg is null");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgIsNotNull() {
            addCriterion("cateLicenceImg is not null");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgEqualTo(String value) {
            addCriterion("cateLicenceImg =", value, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgNotEqualTo(String value) {
            addCriterion("cateLicenceImg <>", value, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgGreaterThan(String value) {
            addCriterion("cateLicenceImg >", value, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgGreaterThanOrEqualTo(String value) {
            addCriterion("cateLicenceImg >=", value, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgLessThan(String value) {
            addCriterion("cateLicenceImg <", value, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgLessThanOrEqualTo(String value) {
            addCriterion("cateLicenceImg <=", value, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgLike(String value) {
            addCriterion("cateLicenceImg like", value, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgNotLike(String value) {
            addCriterion("cateLicenceImg not like", value, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgIn(List<String> values) {
            addCriterion("cateLicenceImg in", values, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgNotIn(List<String> values) {
            addCriterion("cateLicenceImg not in", values, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgBetween(String value1, String value2) {
            addCriterion("cateLicenceImg between", value1, value2, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andCatelicenceimgNotBetween(String value1, String value2) {
            addCriterion("cateLicenceImg not between", value1, value2, "catelicenceimg");
            return (Criteria) this;
        }

        public Criteria andAccnameIsNull() {
            addCriterion("accName is null");
            return (Criteria) this;
        }

        public Criteria andAccnameIsNotNull() {
            addCriterion("accName is not null");
            return (Criteria) this;
        }

        public Criteria andAccnameEqualTo(String value) {
            addCriterion("accName =", value, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameNotEqualTo(String value) {
            addCriterion("accName <>", value, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameGreaterThan(String value) {
            addCriterion("accName >", value, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameGreaterThanOrEqualTo(String value) {
            addCriterion("accName >=", value, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameLessThan(String value) {
            addCriterion("accName <", value, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameLessThanOrEqualTo(String value) {
            addCriterion("accName <=", value, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameLike(String value) {
            addCriterion("accName like", value, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameNotLike(String value) {
            addCriterion("accName not like", value, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameIn(List<String> values) {
            addCriterion("accName in", values, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameNotIn(List<String> values) {
            addCriterion("accName not in", values, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameBetween(String value1, String value2) {
            addCriterion("accName between", value1, value2, "accname");
            return (Criteria) this;
        }

        public Criteria andAccnameNotBetween(String value1, String value2) {
            addCriterion("accName not between", value1, value2, "accname");
            return (Criteria) this;
        }

        public Criteria andAccpassIsNull() {
            addCriterion("accPass is null");
            return (Criteria) this;
        }

        public Criteria andAccpassIsNotNull() {
            addCriterion("accPass is not null");
            return (Criteria) this;
        }

        public Criteria andAccpassEqualTo(String value) {
            addCriterion("accPass =", value, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassNotEqualTo(String value) {
            addCriterion("accPass <>", value, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassGreaterThan(String value) {
            addCriterion("accPass >", value, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassGreaterThanOrEqualTo(String value) {
            addCriterion("accPass >=", value, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassLessThan(String value) {
            addCriterion("accPass <", value, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassLessThanOrEqualTo(String value) {
            addCriterion("accPass <=", value, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassLike(String value) {
            addCriterion("accPass like", value, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassNotLike(String value) {
            addCriterion("accPass not like", value, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassIn(List<String> values) {
            addCriterion("accPass in", values, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassNotIn(List<String> values) {
            addCriterion("accPass not in", values, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassBetween(String value1, String value2) {
            addCriterion("accPass between", value1, value2, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccpassNotBetween(String value1, String value2) {
            addCriterion("accPass not between", value1, value2, "accpass");
            return (Criteria) this;
        }

        public Criteria andAccmailIsNull() {
            addCriterion("accMail is null");
            return (Criteria) this;
        }

        public Criteria andAccmailIsNotNull() {
            addCriterion("accMail is not null");
            return (Criteria) this;
        }

        public Criteria andAccmailEqualTo(String value) {
            addCriterion("accMail =", value, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailNotEqualTo(String value) {
            addCriterion("accMail <>", value, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailGreaterThan(String value) {
            addCriterion("accMail >", value, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailGreaterThanOrEqualTo(String value) {
            addCriterion("accMail >=", value, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailLessThan(String value) {
            addCriterion("accMail <", value, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailLessThanOrEqualTo(String value) {
            addCriterion("accMail <=", value, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailLike(String value) {
            addCriterion("accMail like", value, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailNotLike(String value) {
            addCriterion("accMail not like", value, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailIn(List<String> values) {
            addCriterion("accMail in", values, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailNotIn(List<String> values) {
            addCriterion("accMail not in", values, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailBetween(String value1, String value2) {
            addCriterion("accMail between", value1, value2, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmailNotBetween(String value1, String value2) {
            addCriterion("accMail not between", value1, value2, "accmail");
            return (Criteria) this;
        }

        public Criteria andAccmobileIsNull() {
            addCriterion("accMobile is null");
            return (Criteria) this;
        }

        public Criteria andAccmobileIsNotNull() {
            addCriterion("accMobile is not null");
            return (Criteria) this;
        }

        public Criteria andAccmobileEqualTo(String value) {
            addCriterion("accMobile =", value, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileNotEqualTo(String value) {
            addCriterion("accMobile <>", value, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileGreaterThan(String value) {
            addCriterion("accMobile >", value, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileGreaterThanOrEqualTo(String value) {
            addCriterion("accMobile >=", value, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileLessThan(String value) {
            addCriterion("accMobile <", value, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileLessThanOrEqualTo(String value) {
            addCriterion("accMobile <=", value, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileLike(String value) {
            addCriterion("accMobile like", value, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileNotLike(String value) {
            addCriterion("accMobile not like", value, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileIn(List<String> values) {
            addCriterion("accMobile in", values, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileNotIn(List<String> values) {
            addCriterion("accMobile not in", values, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileBetween(String value1, String value2) {
            addCriterion("accMobile between", value1, value2, "accmobile");
            return (Criteria) this;
        }

        public Criteria andAccmobileNotBetween(String value1, String value2) {
            addCriterion("accMobile not between", value1, value2, "accmobile");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNull() {
            addCriterion("createTime is null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIsNotNull() {
            addCriterion("createTime is not null");
            return (Criteria) this;
        }

        public Criteria andCreatetimeEqualTo(Date value) {
            addCriterion("createTime =", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotEqualTo(Date value) {
            addCriterion("createTime <>", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThan(Date value) {
            addCriterion("createTime >", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeGreaterThanOrEqualTo(Date value) {
            addCriterion("createTime >=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThan(Date value) {
            addCriterion("createTime <", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeLessThanOrEqualTo(Date value) {
            addCriterion("createTime <=", value, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeIn(List<Date> values) {
            addCriterion("createTime in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotIn(List<Date> values) {
            addCriterion("createTime not in", values, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeBetween(Date value1, Date value2) {
            addCriterion("createTime between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andCreatetimeNotBetween(Date value1, Date value2) {
            addCriterion("createTime not between", value1, value2, "createtime");
            return (Criteria) this;
        }

        public Criteria andUplinetimeIsNull() {
            addCriterion("upLineTime is null");
            return (Criteria) this;
        }

        public Criteria andUplinetimeIsNotNull() {
            addCriterion("upLineTime is not null");
            return (Criteria) this;
        }

        public Criteria andUplinetimeEqualTo(Date value) {
            addCriterionForJDBCDate("upLineTime =", value, "uplinetime");
            return (Criteria) this;
        }

        public Criteria andUplinetimeNotEqualTo(Date value) {
            addCriterionForJDBCDate("upLineTime <>", value, "uplinetime");
            return (Criteria) this;
        }

        public Criteria andUplinetimeGreaterThan(Date value) {
            addCriterionForJDBCDate("upLineTime >", value, "uplinetime");
            return (Criteria) this;
        }

        public Criteria andUplinetimeGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("upLineTime >=", value, "uplinetime");
            return (Criteria) this;
        }

        public Criteria andUplinetimeLessThan(Date value) {
            addCriterionForJDBCDate("upLineTime <", value, "uplinetime");
            return (Criteria) this;
        }

        public Criteria andUplinetimeLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("upLineTime <=", value, "uplinetime");
            return (Criteria) this;
        }

        public Criteria andUplinetimeIn(List<Date> values) {
            addCriterionForJDBCDate("upLineTime in", values, "uplinetime");
            return (Criteria) this;
        }

        public Criteria andUplinetimeNotIn(List<Date> values) {
            addCriterionForJDBCDate("upLineTime not in", values, "uplinetime");
            return (Criteria) this;
        }

        public Criteria andUplinetimeBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("upLineTime between", value1, value2, "uplinetime");
            return (Criteria) this;
        }

        public Criteria andUplinetimeNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("upLineTime not between", value1, value2, "uplinetime");
            return (Criteria) this;
        }

        public Criteria andShopmanagerIsNull() {
            addCriterion("shopmanager is null");
            return (Criteria) this;
        }

        public Criteria andShopmanagerIsNotNull() {
            addCriterion("shopmanager is not null");
            return (Criteria) this;
        }

        public Criteria andShopmanagerEqualTo(String value) {
            addCriterion("shopmanager =", value, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerNotEqualTo(String value) {
            addCriterion("shopmanager <>", value, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerGreaterThan(String value) {
            addCriterion("shopmanager >", value, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerGreaterThanOrEqualTo(String value) {
            addCriterion("shopmanager >=", value, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerLessThan(String value) {
            addCriterion("shopmanager <", value, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerLessThanOrEqualTo(String value) {
            addCriterion("shopmanager <=", value, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerLike(String value) {
            addCriterion("shopmanager like", value, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerNotLike(String value) {
            addCriterion("shopmanager not like", value, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerIn(List<String> values) {
            addCriterion("shopmanager in", values, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerNotIn(List<String> values) {
            addCriterion("shopmanager not in", values, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerBetween(String value1, String value2) {
            addCriterion("shopmanager between", value1, value2, "shopmanager");
            return (Criteria) this;
        }

        public Criteria andShopmanagerNotBetween(String value1, String value2) {
            addCriterion("shopmanager not between", value1, value2, "shopmanager");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}